Imports DgvFilterPopup

Public Class frm<OwnerU>_<TableU>

    Private cls<OwnerU>_<TableU>Data As New <OwnerU>_<TableU>DataClass
    Private cls<Database>Data As New <Database>DataClass
    Dim dirty As Boolean = False

    Private Sub frm<OwnerU>_<TableU>_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Load_Grid()
        Dim filterManager As New DgvFilterManager(gridCode)
    End Sub

    Private Sub frm<OwnerU>_<TableU>_FormClosing(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.FormClosing
        If dirty = True Then
            Dim result As DialogResult = MessageBox.Show("Save Changes?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
            If result = Windows.Forms.DialogResult.Yes Then
                bSave.PerformClick()
            Else
                MsgBox("Changes NOT saved.", MsgBoxStyle.Information, "Save")
                dirty = False
            End If
        End If
    End Sub

    Private Sub Load_Grid()
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Try
            With gridCode
                .DataSource = cls<OwnerU>_<TableU>Data.Open
        	<If Loop>
	          <IsPKey>
                .Columns(<ColNo>).DefaultCellStyle.BackColor = Color.LightGray
        	</If Loop>
        	<If Loop>
	          <IsNotPKey>
	          <And>
	          <IsIdentity>
                .Columns(<ColNo>).DefaultCellStyle.BackColor = Color.LightGray
        	</If Loop>
        	<If Loop>
	          <IsNotIdentityCount>
	          <And>
	          <IsNotPKeyCount>
                .Columns(<ColNo>).DefaultCellStyle.BackColor = Color.LightGray
	          <ExitLoop>
        	</If Loop>
        	<If Loop>
	          <IsIdentity>
                .Columns(<ColNo>).ReadOnly = True
	          <IsMoney>
                .Columns(<ColNo>).DefaultCellStyle.Format = "c"
		  <IsSmallMoney>
                .Columns(<ColNo>).DefaultCellStyle.Format = "c"
                  <IsNumber>
                  <And>
                  <IsNotFKey>
                .Columns(<ColNo>).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
        	</If Loop>
            End With
<If Loop>
   <IsFKey>
            Load<FieldU>_ComboBox(gridCode)
</If Loop>
<If Loop>
   <IsDateTimePicker>
            Load<FieldU>_DateTimePicker(gridCode)
</If Loop>
        Catch
        End Try
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

<If Loop>
   <IsFKey>
    Private Sub Load<FieldU>_ComboBox(ByVal grid As DataGridView)
        Try
            Dim <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List As List(Of <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>)
            <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = <OwnerU>_<TableU>_<ROwnerU>_<RTableU>DataClass<MiscTag>.List
            <IsFKey>
            Dim col As New DataGridViewComboBoxColumn()
            col.HeaderText = "<FieldC>"
            col.DataSource = <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List
            col.DataPropertyName = "<FieldC>"
            col.ValueMember = "<RFieldU>"
            col.DisplayMember = "<RDisplayFieldU>"
            grid.Columns.RemoveAt(<ColNo>)
            grid.Columns.Insert(<ColNo>, col)
        Catch ex As Exception
            MessageBox.Show(ex.Message, ex.GetType.ToString)
        End Try
    End Sub

</If Loop>
<If Loop>
   <IsDateTimePicker>
    Private Sub Load<FieldU>_DateTimePicker(ByVal grid As DataGridView)
        Try
            Dim col As New CalendarColumn()
            col.HeaderText = "<FieldC>"
            col.DataPropertyName = "<FieldC>"
            grid.Columns.RemoveAt(<ColNo>)
            grid.Columns.Insert(<ColNo>, col)
        Catch ex As Exception
            MessageBox.Show(ex.Message, ex.GetType.ToString)
        End Try
    End Sub

</If Loop>
    Private Sub gridCode_CellEndEdit(sender As Object, e As DataGridViewCellEventArgs) Handles gridCode.CellEndEdit
        dirty = True
    End Sub

    Private Sub bSave_Click(sender As Object, e As EventArgs) Handles bSave.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        cls<OwnerU>_<TableU>Data.Save(gridCode)
        dirty = False
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bDelete_Click(sender As Object, e As EventArgs) Handles bDelete.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim result As DialogResult = MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
        If result = Windows.Forms.DialogResult.Yes Then
            gridCode.Rows.RemoveAt(gridCode.CurrentRow.Index)
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub gridCode_UserDeletingRow(sender As Object, e As DataGridViewRowCancelEventArgs) Handles gridCode.UserDeletingRow
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        Dim result As DialogResult = MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
        If result = Windows.Forms.DialogResult.Yes Then
            e.Cancel = False
        Else
            e.Cancel = True
        End If
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bCancel_Click(sender As Object, e As EventArgs) Handles bCancel.Click
        dirty = False
        Load_Grid()
    End Sub

    Private Sub bWord_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bWord.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        cls<Database>Data.ExportToWord("Many", Me.Text, gridCode)
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bExcel.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        cls<Database>Data.ExportToExcel("Many", Me.Text, gridCode)
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

    Private Sub bPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bPDF.Click
        Me.Cursor = System.Windows.Forms.Cursors.WaitCursor
        cls<Database>Data.ExportToPDF("Many", Me.Text, gridCode, gridCode.CurrentRow)
        Me.Cursor = System.Windows.Forms.Cursors.Default
    End Sub

End Class

